package com.clkj.xiuzheng.dao.shangcheng;

import com.clkj.xiuzheng.pojo.shangcheng.UserScore;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

/**
 * @author yawang
 * @create 2024/05/17 15:12:11
 **/
@Repository
public interface UserScoreMapper extends Mapper<UserScore> {
    @Select("select sum(score_num) from t_xz_userScore where score_type = 0")
    float getUsedScore();
    @Select("select sum(user_score) from t_xz_user ")
    float getRemainScore();
    @Select("select sum(user_balance) from t_xz_user ")
    double getUsedMoney();
}
